data base management system (DBMS) Practice Questions Answers Test with Solutions & More Shortcuts

Question : 26

This set of related data items is known as a

a) File

b) Record

c) Table

d) None of the above

Question : 27

A treelike structure of records in a database. Select the best fit for answer

a) Hierarchical database structure

b) Relational database structure

c) Multidimensional database structure

d) Sequential database access

Question : 28

Which of the following columns can not be found in the macro design window?

a) Arguments column

b) Comment column

c) Conditions column

d) Actions column

Question : 29

What is the purpose of the page field on a pivot table report?

a) It creates a new page for each type of data

b) It allows the data within the Pivot Table report to be filtered

c) It displays a title for the Pivot Table report

d) None of the above

Question : 30

What happens when you add the asterisk (() from any field list of a query?

a) The table will not include any fields from the table

b) The query sorts the table’s record in the order you specify

c) The query will include every field from the table*

d) The query uses the records from the table without displaying them